Report email keywords
These keywords can be used for customising the email in either the report SUBJECT or MESSAGE fields. If ANY text is entered into a field, the default text is discarded and the entered data takes it place.
#[SENDER]# |
Trading name specified in the system preferences |
#[RECORD]# |
ID of the record being outputted (e.g. Sales order number) |
#[USERID]# |
ID of the current user |
#[USERNAME]# |
Full name of the current user |
#[INCLUDE <id>]# |
Include the text from search with ID of <id> |
#[SQL <query>]# |
<query> represents any valid SQL query. #[SQL]# is evaluated last, meaning that other tags included within the #[SQL]# construct will be correctly evaluated and utilised within the SQL query |